<?php

class EstagioController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
            'postOnly + delete', // we only allow deletion via POST request
        );
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new EstagioUsuario;

        // Uncomment the following line if AJAX validation is needed
        $this->performAjaxValidation($model);

        if (isset($_POST['EstagioUsuario'])) {
            $model->attributes = $_POST['EstagioUsuario'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }
    
    public function actionAutocomplete($campo) {
        $usuario_nome = Yii::app()->request->getParam('term', null);
        
        if (!$usuario_nome || !in_array($campo, array('aluno', 'empresa')))
            throw new CHttpException(400, 'Parametros incorreto');
        
        $dados = array();
        if ($campo == 'aluno') {
            $dados = Yii::app()->db->createCommand()
                ->select('u.id, u.nome AS label, u.email')
                ->from('usuario u')
                ->leftJoin('estagio_usuario eu', 'eu.aluno_id=u.id')
                ->where('(eu.id IS NULL OR eu.data_fim IS NULL) AND u.nome LIKE ? AND u.perfil_id=4', array("%{$usuario_nome}%"))
                ->limit(8)
                ->queryAll();
        } else {
            $dados = Yii::app()->db->createCommand()
                ->select('id, nome AS label, email')
                ->from('usuario u')
                ->where('nome LIKE ? AND perfil_id=5', array("%{$usuario_nome}%"))
                ->limit(8)
                ->queryAll();
        }
        
        echo CJSON::encode($dados);
        Yii::app()->end();
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        $this->performAjaxValidation($model);

        if (isset($_POST['EstagioUsuario'])) {
            $model->attributes = $_POST['EstagioUsuario'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {
        $dataProvider = new CActiveDataProvider('EstagioUsuario');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new EstagioUsuario('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['EstagioUsuario'])) {
            $model->attributes = $_GET['EstagioUsuario'];
            
            if ($model->data_inicio && count(explode('/', $model->data_inicio)) == 3)
                $model->data_inicio = DateTime::createFromFormat('d/m/Y', $model->data_inicio)->format('Y-m-d');
            
            if ($model->data_fim && count(explode('/', $model->data_fim)) == 3)
                $model->data_fim = DateTime::createFromFormat('d/m/Y', $model->data_fim)->format('Y-m-d');
        }

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer $id the ID of the model to be loaded
     * @return EstagioUsuario the loaded model
     * @throws CHttpException
     */
    public function loadModel($id) {
        $model = EstagioUsuario::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param EstagioUsuario $model the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'estagio-usuario-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }
}
